echo "<table width='100%'><tr>

<td valign='top' width='33%'>";
openside("Les 5 Dernires Nouvelles");
$result = dbquery("SELECT * FROM ".$db_prefix."news WHERE `news_cat`='17' ORDER BY news_datestamp DESC LIMIT 0,10");
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['news_subject'], 50);
echo " <img src='".THEME."images/bullet.gif'> <a href='".BASEDIR."news.php?readmore=".$data['news_id']."' class='side'> ".$itemsubject."</a><br />\n";
}
} else {
echo "No News";
}
closeside();
echo "</td> ";

echo "<td valign='top' width='33%'>";
openside("Les 5 Nouvelles Les Plus Lus");
$result = dbquery("select * from ".$db_prefix."news order by news_reads desc limit 5");
while ($data = dbarray($result))
{
$link = BASEDIR."news.php?readmore=".$data['news_id'];
echo '<img src="'.THEME.'images/bullet.gif"> <a href="'.$link.'">'.$data['news_subject'].'</a><br>';
}
closeside();
echo "</td>";

echo "<td valign='top' width='33%'>";
openside("Les 5 Nouveau Membres");

$result = dbquery("SELECT * FROM ".$db_prefix."users ORDER BY `user_id` DESC LIMIT 5");
echo "<table cellpadding='0' cellspacing='0' width='100%'>";

if (dbrows($result) != 0) {
while ($data = dbarray($result)) {
echo "<tr>\n<td class='side-small' align='left'>\n";
echo "<img src='".THEME."images/bullet.gif'> <a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' title='".$data['user_name']."' class='side'>\n";
echo trimlink($data['user_name'], 15)."</a></td><td class='side-small' align='left'> ".showdate("%d-%m-%Y", $data['user_joined'])."</td>\n</tr>\n";
}
}
echo "</table>";
closeside();
echo "</td>

</tr></table>";